﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="zhcx.aspx.cs" Inherits="XYTXL.Web.View.zhcx.zhcx" %>
<%@ Register Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
    Namespace="System.Web.UI" TagPrefix="asp" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
     <title>无锡职业技术学院校友平台</title>
    <link href="../CSS/oa_Mview.css" rel="stylesheet" type="text/css" />
     <link href="../CSS/css-table.css" rel="stylesheet" type="text/css" />
     <link href="../CSS/ASPNET2BaseCss.css" rel="stylesheet" type="text/css" />
  
     <style type="text/css">
         .auto-style3 {
             height: 88px;
         }
         .auto-style4 {
             font-family: "Tahoma", "宋体";
             font-size: 9pt;
             color: #003399;
             border: 1px solid #93bee2;
             color: #333399;
             background-image: url('../Images/bluebuttonbg.gif');
             background-color: #e8f4ff;
             CURSOR: hand;
             font-style: normal;
             margin-top: 0px;
             height: 20px;
         }
     </style>
  
</head>
<body>
    <form id="form1" runat="server">
    <div class="maindiv">
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <table style="width: 100%">
            <tr>
                <td colspan="7" style="vertical-align: middle; width: 100%; height: 40px; background-color: whitesmoke;
                    text-align: center">
                    <asp:Label ID="Label1" runat="server" CssClass="LableCss" Font-Size="12pt" Text="综合查询"></asp:Label></td>
            </tr>
            <tr>
                <td style="width: 10%; text-align: right;">
                    <asp:Label ID="Label2" runat="server" CssClass="LableCss" Text="查询表选择"></asp:Label></td>
                <td style="width: 15%">
                    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                        <ContentTemplate>
                            <asp:DropDownList ID="DDtable" runat="server" CssClass="LableCss" Width="90%" AutoPostBack="True" OnSelectedIndexChanged="DDtable_SelectedIndexChanged">
                            </asp:DropDownList>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                </td>
                <td style="width: 10%; \: ;">
                    <asp:UpdatePanel ID="UpdatePanel6" runat="server">
                        <ContentTemplate>
                            <asp:Button ID="Btcxzd" runat="server" CssClass="ButtonCss" OnClick="Btcxzd_Click" Text="查询字段" />
                        </ContentTemplate>
                    </asp:UpdatePanel>
                    </td>
                <td style="width: 15%">
                    </td>
                <td style="width: 20%">
                    </td>
                <td style="width: 20%">
                    <asp:UpdatePanel ID="UpdatePanel7" runat="server">
                        <ContentTemplate>
                            <asp:Button ID="Bttj" runat="server" CssClass="auto-style4" OnClick="Bttj_Click" Text="生成条件" />
                        </ContentTemplate>
                    </asp:UpdatePanel>
                </td>
                <td style="width: 5%; height: 46px;">
                    <asp:UpdateProgress ID="UpdateProgress1" runat="server">
                        <ProgressTemplate>
                            <asp:Image ID="Image1" runat="server" ImageUrl="~/View/images/runing-5.gif" />
                        </ProgressTemplate>
                    </asp:UpdateProgress>
                </td>
            </tr>          
            <tr>
                <td colspan="7">
                    <asp:Panel ID="Panel1" runat="server" Height="300px" ScrollBars="Vertical" Width="100%">
                        <asp:UpdatePanel ID="UpdatePanel2" runat="server">
                            <ContentTemplate>
                                <asp:GridView ID="GVtable" runat="server" AutoGenerateColumns="False" CssClass="dg1-table" Width="98%" DataKeyNames="fields,fieldsname,tablecode,tablename" OnRowDataBound="GVkbkmd_RowDataBound">
                                    <RowStyle CssClass="dg1-item" />
                                    <SelectedRowStyle CssClass="SeleBackGroundColor" />
                                    <HeaderStyle CssClass="dg1-header2" />
                                    <Columns>
                                        <asp:TemplateField HeaderText="输出选择">
                                            <HeaderTemplate>
                                                <asp:Button ID="BTxz" runat="server" CssClass="ButtonCss" OnClick="BTxz_Click" Text="全选" Width="50px" />
                                            </HeaderTemplate>
                                            <ItemTemplate>
                                                <asp:CheckBox ID="CBxz" runat="server" AutoPostBack="True" OnCheckedChanged="CBxz_CheckedChanged" />
                                            </ItemTemplate>
                                            <ItemStyle Width="10%" />
                                        </asp:TemplateField>
                                        <asp:BoundField DataField="fieldsname" HeaderText="字段名称">
                                        <ItemStyle Width="25%" Wrap="True" />
                                        </asp:BoundField>
                                        <asp:TemplateField HeaderText="条件关系">                                            
                                            <ItemTemplate>
                                                <asp:DropDownList ID="DDfh" runat="server" Width="90%">
                                                    <asp:ListItem>=</asp:ListItem>
                                                    <asp:ListItem>like</asp:ListItem>
                                                    <asp:ListItem>&gt;=</asp:ListItem>
                                                    <asp:ListItem>&gt;</asp:ListItem>
                                                    <asp:ListItem>&lt;=</asp:ListItem>
                                                    <asp:ListItem>&lt;=</asp:ListItem>
                                                </asp:DropDownList>
                                            </ItemTemplate>
                                            <ItemStyle Width="15%" />
                                        </asp:TemplateField>

                                        <asp:TemplateField HeaderText="条件值">                                            
                                            <ItemTemplate>
                                                <asp:TextBox ID="Txttj" runat="server" Width="90%"></asp:TextBox>
                                            </ItemTemplate>
                                            <ItemStyle Width="15%" />
                                        </asp:TemplateField>
                                         <asp:BoundField DataField="sm" HeaderText="条件说明">
                                        <ItemStyle Width="20%" Wrap="True" />
                                        </asp:BoundField>
                                        <asp:TemplateField HeaderText="与 或">                                            
                                            <ItemTemplate>
                                                <asp:DropDownList ID="DDgx" runat="server" Width="90%">
                                                    <asp:ListItem Value="and">与</asp:ListItem>
                                                    <asp:ListItem Value="or">或</asp:ListItem>
                                                </asp:DropDownList>
                                            </ItemTemplate>
                                            <ItemStyle Width="10%" />
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="条件选择">                                            
                                            <ItemTemplate>
                                                <asp:CheckBox ID="CBtjxz" runat="server" AutoPostBack="True" OnCheckedChanged="CBtjxz_CheckedChanged" />
                                            </ItemTemplate>
                                            <ItemStyle Width="10%" />
                                        </asp:TemplateField>
                                    </Columns>
                                </asp:GridView>
                            </ContentTemplate>
                        </asp:UpdatePanel>
                    </asp:Panel>
                </td>
            </tr>
             <tr>
                <td style="text-align: right;" class="auto-style3" colspan="2">
                    <asp:Label ID="Label4" runat="server" CssClass="LableCss" Text="查询表选择"></asp:Label>
                    </td>
                <td class="auto-style3" colspan="5">
                    <asp:UpdatePanel ID="UpdatePanel4" runat="server">
                        <ContentTemplate>
                            <asp:TextBox ID="Txttj" runat="server" Height="60px" TextMode="MultiLine" Width="100%"></asp:TextBox>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                    </td>
            </tr>
             <tr>
                <td style="text-align: right;" colspan="2">
                    <asp:Label ID="Label5" runat="server" CssClass="LableCss" Text="输出字段"></asp:Label>
                    </td>
                <td colspan="5">
                    <asp:UpdatePanel ID="UpdatePanel5" runat="server">
                        <ContentTemplate>
                            <asp:TextBox ID="Txtfields" runat="server" Height="60px" TextMode="MultiLine" Width="100%"></asp:TextBox>
                        </ContentTemplate>
                    </asp:UpdatePanel>
                    </td>
            </tr>
             <tr>
                <td style="width: 5%; text-align: right;" class="dg1-option">
                    </td>
                <td style="width: 15%" class="dg1-option">
                    </td>
                <td style="width: 10%; \: ;" class="dg1-option">
                    <asp:UpdatePanel ID="UpdatePanel8" runat="server">
                        <ContentTemplate>
                            <asp:Button ID="Btcxxx" runat="server" CssClass="ButtonCss" OnClick="Btcxxx_Click" OnClientClick="return confirm('确定要按照条件查询信息吗?');" Text="查询信息" />
                        </ContentTemplate>
                    </asp:UpdatePanel>
                    </td>
                <td style="width: 20%; height: 28px;" class="dg1-option">
                    <asp:UpdatePanel ID="UpdatePanel10" runat="server">
                        <ContentTemplate>
                            <asp:CheckBox ID="CBzdxz" runat="server" Checked="True" CssClass="LableCss" Text="转出中文意义字段" />
                        </ContentTemplate>
                    </asp:UpdatePanel>
                    </td>
                <td style="width: 20%" class="dg1-option">
                    </td>
                <td style="width: 20%" class="dg1-option">
                    <asp:Button ID="dataout" runat="server" CssClass="ButtonCss" OnClick="dataout_Click" Text="数据转出" />
                    </td>
                <td style="width: 5%; " class="dg1-option">
                    </td>
            </tr>
            <tr>
                <td style="width: 100%" colspan="7">
                    <asp:Panel ID="Panel2" runat="server" Height="500px" ScrollBars="Vertical">
                        <asp:UpdatePanel ID="UpdatePanel9" runat="server">
                            <ContentTemplate>
                                <asp:GridView ID="GVdata" runat="server" CssClass="dg1-table">
                                    <HeaderStyle CssClass="dg1-header2" />
                                    <RowStyle CssClass="dg1-item" />
                                </asp:GridView>
                            </ContentTemplate>
                        </asp:UpdatePanel>
                    </asp:Panel>
                    </td>
            </tr>
            <tr>
                <td colspan="7" style="width: 100%; height: 28px;" class="dg1-option">
                </td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>
